package com.hl.sfzy.mapper.wxwappMapper;

import com.hl.sfzy.entity.wxwapp.TeacherDetail;
import com.hl.sfzy.entity.wxwapp.User;
import com.hl.sfzy.entity.wxwapp.WXWConsultwait;
import com.hl.sfzy.entity.wxwapp.WXWConsultwaitName;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
* @author 14821
* @description 针对表【consultWait(咨询预约表，存储用户的咨询预约信息)】的数据库操作Mapper
* @createDate 2024-09-11 22:41:13
* @Entity com.hl.sfzy.entity.wxwapp.Consultwait
*/
@Repository
public interface WXWConsultwaitMapper {

    int deleteByPrimaryKey(Long id);

    int insert(WXWConsultwait record);

    int insertSelective(WXWConsultwait record);

    WXWConsultwait selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(WXWConsultwait record);

    int updateByPrimaryKey(WXWConsultwait record);
    //查询全部预约信息
    List<WXWConsultwaitName> selectReservation();
    //查询所有咨询师的id和name
    List<TeacherDetail> selectTeacherIdAndName();
    //查询所有的user的id和name
    List<User> selectUserIdAndName();
    //根据姓名查询teacher的id
    int selectTeacherIdByName(String name);
    //根据姓名查询user的id
    int selectUserIdByName(String name);
    //根据id查询预约信息（名字的）
    WXWConsultwaitName selectReservationById(Integer id);
    //根据咨询师的姓名模糊查询信息
    List<WXWConsultwaitName> selectReservationByName(List<Integer> ids);
    //根据teacher的姓名模糊查询id
    List<Integer> selectTeacherIdByNameLike(String name);

}
